show all data

[dashusa]

hello i am joining to tables and it looks like this:

SELECT Table1.Check, paths.check, paths.Field1
FROM Table1 INNER JOIN paths ON Query11.Check =Paths.check;

problem is that i want to show all the data in the tables aswell even if the dont match up..
is this posssible.
I have more records in the Table 1 colum.
Thak you D

 

[lespaul]

You need to change the join type, see Understanding SQL Joins.

Not sure what Query11 has to do with this, I would think this SQL wouldn't run?

Leslie

Anything worth doing is a lot more difficult than it's worth - Unknown Induhvidual

Essential reading for anyone working with databases: The Fundamentals of Relational Database Design

 

[dashusa]

Sorry it should have been:

SELECT Table1.Check, paths.check, paths.Field1
FROM Table1 INNER JOIN paths ON Table1.Check =Paths.check

 

[lespaul]

SELECT Table1.Check, paths.check, paths.Field1
FROM Table1 LEFT JOIN paths ON Table1.Check =Paths.check