subquery

R

Rohan

Hi this is my subquery that i have: which doesn't work :

SELECT(SELECT Max([transport de generatrice].ID) AS MaxOfID,
Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU

GROUP BY Generatrice.Nom ORDER BY Max([transport de generatrice].ID)
DESC;) , [transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

I made this query by combining two queres
frist:
SELECT Max([transport de generatrice].ID) AS MaxOfID, Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU
GROUP BY Generatrice.Nom
ORDER BY Max([transport de generatrice].ID) DESC;

Second :
SELECT
[transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

i am getting the fallowing error :
You have written a subquery that can return more than one field without
using the EXISTS reserved word in the main query's FROM clause. Revise
the SELECT statement of the subquery to request only one field. (Error
3306)

Thank you for your help !
 
G

Gary Walter

You can use a subquery (without an ending ";" and
an ORDER BY clause is superfluous) in a
SELECT clause,
FROM clause,
or WHERE clause.

In the SELECT clause, the subquery must provide
only "one result," i.e., only one field and only one value
for that one field.

You can "correlate" the subquery back to the main
query so that "one result" is different depending
on a field (or fields) in the main query.

What are you trying to return from the subquery?
How does the subquery relate back to the main query,
i.e., for every record in the main query, what "one result"
do you want to include from a subquery, and how is that
value arrived at in some relation between the subquery
and the main query?

Without seeing your data, I am at a loss to understand
what you are trying to do...sorry. So, my best *guess* is
that you want to save the first query, then add this query
to the second query "as a table" joining on "MaxOfID"
to return the Nom?

This "divide and conquer" method of saving queries to be
used in further processing will always prove more useful
(vs subqueries) until you understand SQL better. I think
I understand SQL well, but I am still comfortable in saving
queries with well-defined names to be used in this
"divide-and-conquer" manner.

Rohan said:
Hi this is my subquery that i have: which doesn't work :

SELECT(SELECT Max([transport de generatrice].ID) AS MaxOfID,
Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU

GROUP BY Generatrice.Nom ORDER BY Max([transport de generatrice].ID)
DESC;) , [transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

I made this query by combining two queres
frist:
SELECT Max([transport de generatrice].ID) AS MaxOfID, Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU
GROUP BY Generatrice.Nom
ORDER BY Max([transport de generatrice].ID) DESC;

Second :
SELECT
[transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

i am getting the fallowing error :
You have written a subquery that can return more than one field without
using the EXISTS reserved word in the main query's FROM clause. Revise
the SELECT statement of the subquery to request only one field. (Error
3306)

Thank you for your help !
Click to expand...
 
R

Rohan

Let me explain it to you
i have a table that keeps records of Transerfers by dates, Start
Address and Destinatin Address, in this table there are item that can
be transfered from one place to another i want to select all the item
by group but with the recent dates
i made this SQL, For some reaon The Current address is not coresponding
it is giving me a nother address, it seems that it is sorting by
lastest date thank you

SELECT DISTINCT Last([transport de generatrice].ID) AS LastOfID,
[transport de generatrice].Nom, Last([transport de
generatrice].UpdateDate) AS LastOfUpdateDate, Last([BU
details_1].[Alpha name]) AS [Primary Address],
Last(CurrentAddress([transport de generatrice]![Destination_Add],[BU
details]![Alpha name],Nz([transport de
generatrice]![Destination_add_sec],""))) AS CurentADD
FROM (([transport de generatrice] INNER JOIN [BU details] ON [transport
de generatrice].Destination_Add = [BU details].BU) INNER JOIN
Generatrice ON [transport de generatrice].Nom = Generatrice.Nom) INNER
JOIN [BU details] AS [BU details_1] ON Generatrice.Primary_Location_ID
= [BU details_1].BU
GROUP BY [transport de generatrice].Nom
ORDER BY Last([transport de generatrice].ID);

Gary said:
You can use a subquery (without an ending ";" and
an ORDER BY clause is superfluous) in a
SELECT clause,
FROM clause,
or WHERE clause.

In the SELECT clause, the subquery must provide
only "one result," i.e., only one field and only one value
for that one field.

You can "correlate" the subquery back to the main
query so that "one result" is different depending
on a field (or fields) in the main query.

What are you trying to return from the subquery?
How does the subquery relate back to the main query,
i.e., for every record in the main query, what "one result"
do you want to include from a subquery, and how is that
value arrived at in some relation between the subquery
and the main query?

Without seeing your data, I am at a loss to understand
what you are trying to do...sorry. So, my best *guess* is
that you want to save the first query, then add this query
to the second query "as a table" joining on "MaxOfID"
to return the Nom?

This "divide and conquer" method of saving queries to be
used in further processing will always prove more useful
(vs subqueries) until you understand SQL better. I think
I understand SQL well, but I am still comfortable in saving
queries with well-defined names to be used in this
"divide-and-conquer" manner.

Rohan said:
Hi this is my subquery that i have: which doesn't work :

SELECT(SELECT Max([transport de generatrice].ID) AS MaxOfID,
Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU

GROUP BY Generatrice.Nom ORDER BY Max([transport de generatrice].ID)
DESC;) , [transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

I made this query by combining two queres
frist:
SELECT Max([transport de generatrice].ID) AS MaxOfID, Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU
GROUP BY Generatrice.Nom
ORDER BY Max([transport de generatrice].ID) DESC;

Second :
SELECT
[transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

i am getting the fallowing error :
You have written a subquery that can return more than one field without
using the EXISTS reserved word in the main query's FROM clause. Revise
the SELECT statement of the subquery to request only one field. (Error
3306)

Thank you for your help !
Click to expand...
Click to expand...
 
M

Michel Walsh

Hi,


A sub-SELECT in the SELECT clause can only return one row. It seems it
returns 2 fields, and probably more than a single row, since it is based on
a GROUP BY.


Hoping it may help,
Vanderghast, Access MVP
 
M

Michel Walsh

Hi,


Is suspect the problem does not seem to come from your query, but from the
function CurrentAddress. And you don't need to use DISTINCT if you use GROUP
BY... at least, I fail to see any reason, since each group WILL BE distinct,
and if one selected field is 'distinct', in one row, from any other tow,
then, the whole row is also 'distinct'.



Hoping it may help,
Vanderghast, Access MVP

Rohan said:
Let me explain it to you
i have a table that keeps records of Transerfers by dates, Start
Address and Destinatin Address, in this table there are item that can
be transfered from one place to another i want to select all the item
by group but with the recent dates
i made this SQL, For some reaon The Current address is not coresponding
it is giving me a nother address, it seems that it is sorting by
lastest date thank you

SELECT DISTINCT Last([transport de generatrice].ID) AS LastOfID,
[transport de generatrice].Nom, Last([transport de
generatrice].UpdateDate) AS LastOfUpdateDate, Last([BU
details_1].[Alpha name]) AS [Primary Address],
Last(CurrentAddress([transport de generatrice]![Destination_Add],[BU
details]![Alpha name],Nz([transport de
generatrice]![Destination_add_sec],""))) AS CurentADD
FROM (([transport de generatrice] INNER JOIN [BU details] ON [transport
de generatrice].Destination_Add = [BU details].BU) INNER JOIN
Generatrice ON [transport de generatrice].Nom = Generatrice.Nom) INNER
JOIN [BU details] AS [BU details_1] ON Generatrice.Primary_Location_ID
= [BU details_1].BU
GROUP BY [transport de generatrice].Nom
ORDER BY Last([transport de generatrice].ID);

Gary said:
You can use a subquery (without an ending ";" and
an ORDER BY clause is superfluous) in a
SELECT clause,
FROM clause,
or WHERE clause.

In the SELECT clause, the subquery must provide
only "one result," i.e., only one field and only one value
for that one field.

You can "correlate" the subquery back to the main
query so that "one result" is different depending
on a field (or fields) in the main query.

What are you trying to return from the subquery?
How does the subquery relate back to the main query,
i.e., for every record in the main query, what "one result"
do you want to include from a subquery, and how is that
value arrived at in some relation between the subquery
and the main query?

Without seeing your data, I am at a loss to understand
what you are trying to do...sorry. So, my best *guess* is
that you want to save the first query, then add this query
to the second query "as a table" joining on "MaxOfID"
to return the Nom?

This "divide and conquer" method of saving queries to be
used in further processing will always prove more useful
(vs subqueries) until you understand SQL better. I think
I understand SQL well, but I am still comfortable in saving
queries with well-defined names to be used in this
"divide-and-conquer" manner.

Rohan said:
Hi this is my subquery that i have: which doesn't work :

SELECT(SELECT Max([transport de generatrice].ID) AS MaxOfID,
Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU

GROUP BY Generatrice.Nom ORDER BY Max([transport de generatrice].ID)
DESC;) , [transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

I made this query by combining two queres
frist:
SELECT Max([transport de generatrice].ID) AS MaxOfID, Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU
GROUP BY Generatrice.Nom
ORDER BY Max([transport de generatrice].ID) DESC;

Second :
SELECT
[transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

i am getting the fallowing error :
You have written a subquery that can return more than one field without
using the EXISTS reserved word in the main query's FROM clause. Revise
the SELECT statement of the subquery to request only one field. (Error
3306)

Thank you for your help !
Click to expand...
Click to expand...
Click to expand...
 
G

Gary Walter

Rohan said:
Let me explain it to you
i have a table that keeps records of Transerfers by dates, Start
Address and Destinatin Address, in this table there are item that can
be transfered from one place to another i want to select all the item
by group but with the recent dates
i made this SQL, For some reaon The Current address is not coresponding
it is giving me a nother address, it seems that it is sorting by
lastest date thank you

SELECT DISTINCT Last([transport de generatrice].ID) AS LastOfID,
[transport de generatrice].Nom, Last([transport de
generatrice].UpdateDate) AS LastOfUpdateDate, Last([BU
details_1].[Alpha name]) AS [Primary Address],
Last(CurrentAddress([transport de generatrice]![Destination_Add],[BU
details]![Alpha name],Nz([transport de
generatrice]![Destination_add_sec],""))) AS CurentADD
FROM (([transport de generatrice] INNER JOIN [BU details] ON [transport
de generatrice].Destination_Add = [BU details].BU) INNER JOIN
Generatrice ON [transport de generatrice].Nom = Generatrice.Nom) INNER
JOIN [BU details] AS [BU details_1] ON Generatrice.Primary_Location_ID
= [BU details_1].BU
GROUP BY [transport de generatrice].Nom
ORDER BY Last([transport de generatrice].ID);
Click to expand...

It appears you have something like:

[transport de generatrice] [BU details]

ID |------BU
UpdateDate | [Alpha name]
Destination_Add-----------|
Destination_add_sec
Nom-|
| [BU details_1]
|
| |-----BU
| | [Alpha
name]
| |
| [Generatrice] |
|----Nom |
Primary_Location_ID----|

In a "divide-and-conquer" strategy,
I'd maybe start with the following query
(name it "qryTransportNomOfLatestDate")

SELECT
t.ID,
t.UpdateDate,
t.Destination_Add,
t.Destination_add_sec,
t.Nom
FROM
[transport de generatrice] AS t
WHERE
t.UpdateDate =
(SELECT
Max(u.UpdateDate)
FROM
[transport de generatrice] AS u
WHERE
u.Nom = t.Nom);

From here it depends on your data...

i.e., does the above give you one record
for each Nom?

-- Then just join query to tables as above...

or, does it give you more than one record
for each Nom (because maybe on same date,
Nom was sent to more than one destination)?

-- Not knowing your data, it may be you wanted
the query above to return latest record for each
"group" of Nom and Destination_Add?

SELECT
t.ID,
t.UpdateDate,
t.Destination_Add,
t.Destination_add_sec,
t.Nom
FROM
[transport de generatrice] AS t
WHERE
t.UpdateDate =
(SELECT
Max(u.UpdateDate)
FROM
[transport de generatrice] AS u
WHERE
u.Nom = t.Nom
AND
u.Destination_Add = t.Destination_Add);

or, on the same date, can more than record
exist for each "group" of Nom and Destination_Add?

-- which record do you want from this "group" then?

Does the sec address enter into the equation then?

Or, do you not care, just return one?

SELECT
First(t.ID) AS FirstID,
t.UpdateDate,
t.Destination_Add,
t.Destination_add_sec,
t.Nom
FROM
[transport de generatrice] AS t
WHERE
t.UpdateDate =
(SELECT
Max(u.UpdateDate)
FROM
[transport de generatrice] AS u
WHERE
u.Nom = t.Nom
AND
u.Destination_Add = t.Destination_Add)
GROUP BY
t.UpdateDate,
t.Destination_Add,
t.Destination_add_sec,
t.Nom;

















Gary said:
You can use a subquery (without an ending ";" and
an ORDER BY clause is superfluous) in a
SELECT clause,
FROM clause,
or WHERE clause.

In the SELECT clause, the subquery must provide
only "one result," i.e., only one field and only one value
for that one field.

You can "correlate" the subquery back to the main
query so that "one result" is different depending
on a field (or fields) in the main query.

What are you trying to return from the subquery?
How does the subquery relate back to the main query,
i.e., for every record in the main query, what "one result"
do you want to include from a subquery, and how is that
value arrived at in some relation between the subquery
and the main query?

Without seeing your data, I am at a loss to understand
what you are trying to do...sorry. So, my best *guess* is
that you want to save the first query, then add this query
to the second query "as a table" joining on "MaxOfID"
to return the Nom?

This "divide and conquer" method of saving queries to be
used in further processing will always prove more useful
(vs subqueries) until you understand SQL better. I think
I understand SQL well, but I am still comfortable in saving
queries with well-defined names to be used in this
"divide-and-conquer" manner.

Rohan said:
Hi this is my subquery that i have: which doesn't work :

SELECT(SELECT Max([transport de generatrice].ID) AS MaxOfID,
Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU

GROUP BY Generatrice.Nom ORDER BY Max([transport de generatrice].ID)
DESC;) , [transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

I made this query by combining two queres
frist:
SELECT Max([transport de generatrice].ID) AS MaxOfID, Generatrice.Nom
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU
GROUP BY Generatrice.Nom
ORDER BY Max([transport de generatrice].ID) DESC;

Second :
SELECT
[transport de generatrice].*, IIf([transport de
generatrice]![Destination_Add]="40000",[transport de
generatrice]![Destination_add_sec],[BU details]![Alpha name]) AS
Adresse
FROM ([Invent_Gen ollie] LEFT JOIN [transport de generatrice] ON
[Invent_Gen ollie].MaxOfID = [transport de generatrice].ID) LEFT JOIN
[BU details] ON [transport de generatrice].Destination_Add = [BU
details].BU;

i am getting the fallowing error :
You have written a subquery that can return more than one field without
using the EXISTS reserved word in the main query's FROM clause. Revise
the SELECT statement of the subquery to request only one field. (Error
3306)

Thank you for your help !
Click to expand...
Click to expand...
Click to expand...
 
R

Rohan

hi Mr.Walter and The others, This is how my basic table structure
look's like !

[transport de generatrice] [Generatrice] [BU details]

Nom <---------------------------------->Nom
|------> BU<-----------|
Destination_Add---------------------| Primary_Location_ID----|
[Alpha name] |
Destination_add_sec | Power |
UpdateDate | ETC |
| |

|-------------------------------------------------|

So basicly what i am was doing is grouping by [transport de
generatrice].Nom and also sorting by recent date, which
would give me the latest one from each item, i would join the
[Generatrice].Nom = [transport de generatrice].Nom in
the query to get various informations, The [BU details] contains all
the address information, therfore i would get the
address by text and not numbers because this is going in to a report.
i have solved my problem by doing two querys which i didn't really want
to but i didn't
have a choice

A frist query would grouping by [transport de generatrice].Nom and also
sorting by recent date:
SELECT Generatrice.Nom, Max([transport de generatrice].ID) AS MaxOfID,
[BU details].[Alpha name], Generatrice.no_remorq,
Generatrice.Responsable, Generatrice.puissance,
Generatrice.Responsable, Generatrice.Appartenence
FROM (([BU details] INNER JOIN Generatrice ON [BU details].BU =
Generatrice.Primary_Location_ID) INNER JOIN [transport de generatrice]
ON Generatrice.Nom = [transport de generatrice].Nom) INNER JOIN [BU
details] AS [BU details_1] ON [transport de
generatrice].Destination_Add = [BU details_1].BU
GROUP BY Generatrice.Nom, [BU details].[Alpha name],
Generatrice.no_remorq, Generatrice.Responsable, Generatrice.puissance,
Generatrice.Responsable, Generatrice.Appartenence
ORDER BY Max([transport de generatrice].ID) DESC;

a second query would use the frist query and get the various
infomation:
SELECT [Invent_Gen SubQ].MaxOfID, [transport de generatrice].*,
IIf([transport de generatrice]!Destination_Add="400*",[transport de
generatrice]!Destination_add_sec,[BU details]![Alpha name]) AS Adresse,
[Invent_Gen SubQ].[Alpha name] AS PrimADD, [Invent_Gen SubQ].no_remorq,
[Invent_Gen SubQ].puissance, [Invent_Gen SubQ].Responsable, [Invent_Gen
SubQ].Appartenence
FROM ([Invent_Gen SubQ] LEFT JOIN [transport de generatrice] ON
[Invent_Gen SubQ].MaxOfID=[transport de generatrice].ID) LEFT JOIN [BU
details] ON [transport de generatrice].Destination_Add=[BU details].BU;


Mr.Walter

Yes the frist query that you have sugested gives me a one record for
each nom, the 2ndand 3rd gives me multiple record with same name
this is not what i wanted,

p.s Thank you for help me, i am stil trying to understand the
divide-and-conquer" strategy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Subquery help 7
"Query must use updateable query" error message 2
Delete Dups Query Failing 5
Subquery help? 3
Year to Date subquery 7
subquery help 1
SubQuery or SubReport?? 13
followup - what makes this query not updatable? 3

Top