Re: [SQL] sql hard question

2001-06-05 Thread Josh Berkus
Limlim, Please post table definitions and some sample data. Your problem does not look that challenging and there is probably a simple reason that you're having trouble with it. > i am trying to build a query in sql that compares between 2 tables > one > hold to field and the other hold the 2 f

[SQL] sql hard question

2001-06-05 Thread limlim
i am trying to build a query in sql that compares between 2 tables one hold to field and the other hold the 2 fields in one example: table1:EN,12 table2:EN.12 how can i compare between the tables throw that field i try with this query but it doesnt work: SELECT * FROM dbo.CNT_DOC_LANGS x INNER JO