+ Reply to Thread
Results 1 to 2 of 2

Thread: cross-join

  1. #1
    Junior Member
    Join Date
    Jan 2012
    Posts
    31

    cross-join

    Hi , i want to cross join these two table
    Code:
    Select * from t1 cross join select * from t2
    But i get error .

  2. #2
    Junior Member
    Join Date
    Jan 2012
    Posts
    10
    The result set of the Cross Join is the number of rows in the first table multiplied by the number of rows in the second table
    Code:
    SELECT t1.Column1, t1.Colum2, t2.ColumnName FROM t1
    CROSS JOIN t2

+ Reply to Thread

Tags for this Thread

Bookmarks

Posting Permissions

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