Howdy, Stranger!

It looks like you're new here. If you want to get involved, click one of these buttons!

Categories

get coloums from more than one table

harsh_shethharsh_sheth Member Posts: 5
hi guys

i wanted to know if it is possible to retrieve coloums from more than one tables where tables are NOT logically related with each other.

i was wondering if this could be done through View.

thanks

Comments

  • ShanooShanoo Member Posts: 32
    Yes, you can use cross join to do that. e.g:

    Select * From Table1 Cross Join Table2

    or

    Select * From Table1, Table2

    But remember, Cross Join is an unconditional join so each record of the first table will join with every single record of the second table. That means if Table1 has M records and Table2 has N records then the resulset will be M x N records.

    - HTH

  • harsh_shethharsh_sheth Member Posts: 5
    thanks

    : Yes, you can use cross join to do that. e.g:
    :
    : Select * From Table1 Cross Join Table2
    :
    : or
    :
    : Select * From Table1, Table2
    :
    : But remember, Cross Join is an unconditional join so each record of the first table will join with every single record of the second table. That means if Table1 has M records and Table2 has N records then the resulset will be M x N records.
    :
    : - HTH
    :
    :

Sign In or Register to comment.