CodeGuru Home VC++ / MFC / C++ .NET / C# Visual Basic VB Forums Developer.com
Results 1 to 3 of 3

Thread: mesh 2 tables

  1. June 28th, 2001, 09:24 AM #1
    dan.h
    dan.h is offline Member
    Join Date
    Oct 2000
    Posts
    52

    mesh 2 tables

    I need to mesh two (sometimes more)tables,of last names, and combining them into one recordset, displaying them in alphabeltical order.I think I have to use the SQL statement CROSS JOIN but I am unsure.
    thanks
    dan.h


    Reply With Quote Reply With Quote
  2. June 28th, 2001, 09:44 AM #2
    Iouri
    Iouri is offline Elite Member
    Join Date
    May 2000
    Location
    New York, NY, USA
    Posts
    2,878

    Re: mesh 2 tables

    use UNION

    sSQL = "SELECT CompanyName,City FROM Suppliers WHERE Country = 'Brazil' UNION" _
    & " SELECT CompanyName, City FROM Customers WHERE Country = 'Brazil';"



    Iouri Boutchkine
    [email protected]
    Iouri Boutchkine
    [email protected]
    Reply With Quote Reply With Quote
  3. June 28th, 2001, 11:02 AM #3
    dan.h
    dan.h is offline Member
    Join Date
    Oct 2000
    Posts
    52

    Re: mesh 2 tables

    Thanks
    That was what I needed!
    dan.h

    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules




Click Here to Expand Forum to Full Width

Featured