multiple table results as one table in dataset

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance

From: Raheel Hussain (raheelphp_at_yahoo.com)
Date: 05/20/04 

Date: Thu, 20 May 2004 02:03:18 -0700

hi,

I have a problem in returning data from multiple table as one table into
a dataset.

as we know that in dataset we can populate it with multiple tables, but
what if
i want the result of a following query which is coming from multiple
tables to be put into
a dataset

select * from Table1,Table2,Table3 where Table2.RecID=Table1.RecID and
Table3.RecID=Table2.RecID and Table1.RecID=5

regards

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

Relevant Pages

  • Re: Prospective Client Tracking Database
    ... TblCompanyContactID ... options to populate for me to choose from. ... there can be multiple contacts and multiple properties, ... there are a bunch of fields relating to the area (phone, email, address, ...
    (microsoft.public.access.tablesdbdesign)
  • Re: select multiple items from dropdown
    ... and then populate this to a field in a database. ... If set to Simple or Extended multiple ... selections are allowed, ... - i earlier had a listbox in the form, this allowed me to enter one name. ...
    (microsoft.public.access.forms)
  • Re: select multiple items from dropdown
    ... george, i feel like an idiot for not reading your post carefully. ... but i have not been able to select multiple ... items in a form to populate a filed using that. ... - i earlier had a listbox in the form, this allowed me to enter one name. ...
    (microsoft.public.access.forms)
  • Re: Prospective Client Tracking Database
    ... And then each Company have multiple Contacts? ... not all contacts entered into database) ... options to populate for me to choose from. ... created relationships amongst the tables be relating the contacts' ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Basic SQL
    ... John Gilson wrote: ... have multiple values for column b, but cannot figure it out - can someone help? ... Regards ... Given the original poster's stated input and required output, your query doesn't ...
    (comp.databases)