incomplete query

[IOI]

Hi,
I have to tables. In both are names, some duplicate, some ginuine.

When I run query choosing just a name column from each table, it doesn't return all names. It just give me duplicate ones.

How to have all names included in the query list?

Cheers

 

[ajetrumpet]

Is there a relationship between the 2 tables??

What is the SQL statement you are using??

 

[IOI]

there is only one relation between tables, it's related by name field/column...

I use wizard, not sure about sql...

 

[ajetrumpet]

1) Open your query > click on views > SQL view (copy and paste your SQL from that window to this thread

2) All relationships are related by COLUMNS. What is the relationship (one-to-many, one-to-one, many-to-many)?? What are the two columns that are joined in the relationship?? If you don't know, open your relationships window and look.

 

[IOI]

SELECT [Dec 2005].Nick AS [Dec 2005_Nick], [Jan 2006].Nick AS [Jan 2006_Nick]
FROM [Dec 2005] INNER JOIN [Jan 2006] ON [Dec 2005].[Nick] = [Jan 2006].[Nick];


columns with names are called nick for now, cause access didn't allow me to use word 'name'

1 nick column from each table is related...it says one-to-one...

 

[ajetrumpet]

SELECT [Dec 2005].Nick AS [Dec 2005_Nick], [Jan 2006].Nick AS [Jan 2006_Nick]
FROM [Dec 2005] INNER JOIN [Jan 2006] ON [Dec 2005].[Nick] = [Jan 2006].[Nick];

Try this one instead...

SELECT [Dec 2005].Nick AS [Dec 2005_Nick] 
FROM [Dec 2005]

UNION

SELECT [Jan 2006].Nick AS [Jan 2006_Nick]
FROM [Jan 2006]

 

[IOI]

cheers, it works...it seems I need to learn some sql

 

[ajetrumpet]

It might help...although it is a bit different between database programs.

I LOVE oracle, but then again, that is the king of database language. Access isn't bad though.

 

[IOI]

I might try oracle...which version is the most user friendly if you know what I'm mean...

would it be more useful for my stats?

I do have 25 tables with names [duplicate and not] and numbers and would like generate report/query summing all that stuff...

 

[ajetrumpet]

Every database program does something different.

Access isn't even the only database software from Microsoft. You will have to test them out and see what ya think. Good Luck!!