Post reply

?? on linking two table to one ??

  • February 6, 2015 at 11:30 am

    #294594

    Hi

    This may sound basic, but here is my problem

    I have table1(Client widgets) and Table2(Client Toys) I want to link both Table1 and table2 up to Table3(ClientNames)

    All tables have a clientid field

    I want to right join them so I get all the client widgets and Client toys for each client

    Thanks

    Joe

  • February 6, 2015 at 11:44 am

    #1776134

    Thinking about it ... I think I need to do a UNION ?

  • February 6, 2015 at 12:39 pm

    #1776146

    It depends on the output you want

    Do you want one result set where each row has either a toy or a widget, and the client they are linked to? That would be the union scenario, or more appropriately UNION ALL as hopefully the toys and widgets would not duplicate each other

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply