Is it possible to write single query on two table which are not connected to each other?

by

A Cartesian join (note there is no JOIN condition). All possible combinations of records are in the results:

tableA (charfield Char(2))
tableB (numberfield Number(1))

INSERT 'A' INTO tableA;
INSERT 'B' INTO tableA;
INSERT 1 INTO tableB;
INSERT 2 INTO tableB;

SELECT * 
FROM   tablea CROSS JOIN tableb

Results:

charfield|numberfield
=====================
A        |1
A        |2
B        |1
B        |2

More Related Contents:

  1. SET versus SELECT when assigning variables?
  2. How to print VARCHAR(MAX) using Print Statement?
  3. Concatenate values based on ID
  4. Splitting delimited values in a SQL column into multiple rows
  5. Cumulative Total in MS Sql server [duplicate]
  6. T-SQL split string
  7. How to update two tables in one statement in SQL Server 2005?
  8. Conditional WHERE clause in SQL Server
  9. Create a date from day month and year with T-SQL
  10. Is the NOLOCK (Sql Server hint) bad practice?
  11. Multi-statement Table Valued Function vs Inline Table Valued Function
  12. How to return multiple values in one column (T-SQL)?
  13. SQL – Subtracting a depleting value from rows
  14. Parse comma-separated string to make IN List of strings in the Where clause
  15. SELECT FOR UPDATE with SQL Server
  16. Compare DATETIME and DATE ignoring time portion
  17. EXISTS vs JOIN and use of EXISTS clause
  18. Split function in SQL Server 2008
  19. Cannot use a CONTAINS or FREETEXT predicate on table or indexed view because it is not full-text indexed
  20. How to split string using delimiter char using T-SQL?
  21. OPENXML with xmlns:dt
  22. SQL server select distinct rows using most recent value only
  23. How can I group by date time column without taking time into consideration
  24. Eliminate and reduce overlapping date ranges
  25. SQL Server SELECT INTO @variable?
  26. Use variable with TOP in select statement in SQL Server without making it dynamic [duplicate]
  27. How do I find the data directory for a SQL Server instance?
  28. Compare dates in T-SQL, ignoring the time part
  29. Sql Server : How to use an aggregate function like MAX in a WHERE clause
  30. SQL Server: +(unary) operator on non-numeric Strings

Leave a Comment