PC Review


Reply
Thread Tools Rate Thread

reference multipal table records

 
 
=?Utf-8?B?UXVhbmRhcnk=?=
Guest
Posts: n/a
 
      5th Apr 2005
i am trying to hack a SQL statement and i cant figure it out. will some one
please show me what im doing wrong. i want to reference multiple tables in a
report

SELECT DISTINCTROW [AssetsHardware].*, [AssetsSoftware].*,
[AssetsPrinters].*, [LastName] & ", " & [FirstName] AS [Employee Name] FROM
[Employees] RIGHT JOIN [AssetsHardware], [AssetsSoftware], [AssetsPrinters]
ON [Employees].[EmployeeID] = [AssetsHardware].[EmployeeID],
[AssetsSoftware]. [EmployeeID], [AssetsPrinters].[EmployeeID];
 
Reply With Quote
 
 
 
Reply

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Can you write a formul that will put multipal answers in multipal. =?Utf-8?B?SmlsbF8=?= Microsoft Excel Worksheet Functions 1 3rd Apr 2006 11:00 PM
Can you write a formul that will put multipal answers in multipal. =?Utf-8?B?SmlsbF8=?= Microsoft Excel Worksheet Functions 0 3rd Apr 2006 10:05 PM
How to reference multipal cells in VBA mikewild2000 Microsoft Excel Worksheet Functions 2 29th Jan 2004 08:56 PM
Re: Removing multipal installs of XP pro. Carey Frisch [MVP] Windows XP Help 0 11th Dec 2003 05:23 PM
multipal copies printing problam agnel Windows XP Print / Fax 1 14th Nov 2003 10:19 PM


Features
 

Advertising
 

Newsgroups
 


All times are GMT +1. The time now is 01:00 PM.