March 19, 2009 at 4:18 am
test
March 19, 2009 at 4:34 am
could you show us what you have so far?
----------------------------------------------
Try to learn something about everything and everything about something. - Thomas Henry Huxley
:w00t:
Posting Best Practices[/url]
Numbers / Tally Tables[/url]
March 19, 2009 at 5:22 am
Hi,
It will be more understandable if you post your query with sample data. Its ok, from your query I understand that you want to display all records of "DEWI" where Source equal to 'Production' and 'TypeofTech' in "PWI" equal to '.NET'.
Try this, hope it may help you....
SELECT DEWI.* FROM PWI
INNER JOIN DWI ON DWI.PWIID = PWI.ID
INNER JOIN DEWI ON DEWI.DWIID = DWI.ID
WHERE
PWI.TYPEOFTECH = '.NET'
AND DEWI.SOURCE = 'PRODUCTION'
Regards,
Ashok S
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply