multiple table results as one table in dataset

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: 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: 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)
  • Re: select multiple items from dropdown
    ... and then populate this to a field in a database. ... Listboxes have a MultiSelect property. ... multiple selections are allowed, ... Rick Brandt, Microsoft Access MVP ...
    (microsoft.public.access.forms)
  • Re: Basic SQL
    ... John Gilson wrote: ... have multiple values for column b, but cannot figure it out - can someone help? ... The results of the query when running against the above data ... Regards ...
    (comp.databases)