Hi Ben,

> If you're trying to join two tables, you need a common column (field) in
> both tables.
> E.g. to join Invoice table to Invoice_Details you would have a common
field
> Invoice_nbr in both tables.

Ahh, thought so. That means I can't do it then - damn it.

> You said "this is out of my depth" -- you might benefit from a good
> beginning book on SQL.  I really like Ben Forta's "Teach Yourself SQL in
10
> Minutes" by Sams, ISBN 0-672-31664-1, US $12.99.  It has a lot of material
> on why and how to join tables.
>

Yes, I ordered one the other day from Amazon - should arrive tomorrow :)

Will

--
[EMAIL PROTECTED] -=- www.lukrative.com
Local-Advertising -=- www.localbounty.com


~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at 
http://www.fusionauthority.com/bkinfo.cfm

Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists

Reply via email to