SQL join on two tables

[mcginty]

Hi,

I am trying to select data from two tables which have no foreign key. Can I join these two tables using two fields in each table? eg. select tbl1.a, table1.b from table1, table2 where table1.a=tbl2.a and table1.b=table2.b

I've tried inner joins with no success.
Thanks in advance,
Mac

 

[foxdev]

Yes, in fact the syntax you used is pretty much it, unless you want to use the ANSI 92 JOIN syntax. Robert Bradley

http://www.foxdev.com/

Got extra money lying around? Visit:

http://www.agrainofhope.org

 

[fluteplr]

If you are doing what you said and it is not working check for field lengths on the various tables. I.E. are table.a and table2.a the same length if not you will have various problems due to the way fields are matched, try to put the longer field on the left of the equals and see if that helps. You could also trim or pad the fields to make them equal length.