Is there a way of joining results from 2 tables without using JOIN or SELECT from more than one table? The reason being the database im working with requires queries that only contain SELECT, FROM, and WHERE clauses containing only one distinct table. I do, however, need information from other tables for the project i'm working on.
More info: the querier returns the query results in a .csv format, is there something we can manipulate there?
views:
119answers:
2
Q:
methods of joining 2 tables without using JOIN or SELECT more than one distinct table in the query
That's ANSI-89 join syntax - without any criteria, it's a cross join which'll produce a cartesian product. Not downvoting, just saying.
OMG Ponies
2010-03-19 15:50:49
Point taken....
Andersson
2010-03-19 16:29:48
+1
A:
Pick a programming language. Any language will do. Run one query, and get the results. Run another query, get the results. Use the programming language to combine the results.
Seriously. You are asking how to join data from a database that doesn't support joins. If the database doesn't support it, you're going to have to do it externally.
Matthew Flynn
2010-03-19 18:21:45