Query Check

[sshr]

(select (iif (max([second table].[publishing]) = "True", "Yes", iif (max([first table].[publishing]) = "False", "No", "Error")) from [first table] group by [second table].url where ((([first table].[site url] = [second table].Url))) as haspublish



I have to put this query inside another query so that the output table is complete...

Please let me know if there is any mistake...

Publish has blank, true or false as string

I have tables as
Table 1
url ........
a
b

Table 2
Site Url Extend Publishing
a a/b False
a a/c False
a a/d False
b b/e False
b b/f True
b b/g False

Result Query needed:
Url Publish
a False
b True

Thanks in advance

[June7]

Best way to find out if it has errors is to run it. When it accomplishes what you want, then nest it into the other query.

[sshr]

Even if i do it seperately, the values are all wrong!!

I think the max() is all wrong!!! I could not figure what to do next!!!

[June7]

What is [what is]? This should be one of the two table names.

Not understanding why the first table criteria.

If the True/False field is a Yes/No datatype, try:
SELECT [Second Table].[Site URL], Max(Iif(Publishing=True,"Yes","No")) AS MaxOfPublishing
FROM [Second Table]
GROUP BY [Second Table].[Site URL];

It it is a text datatype, try:
SELECT [Second Table].[Site URL], Max([Second Table].Publishing) AS MaxOfPublishing
FROM [Second Table]
GROUP BY [Second Table].[Site URL];

[sshr]

I got the code running if i run the code alone... but when I add it as a subquery it says the subquery cannot have more than 1 value!!!

The code I could run is
select iif(max([second table].publish)="True", "yes", "No")
from [first table],[second table]
where [second table].[site url]=[first table].url
group by [first table].url

Actually publish is the text string!

[June7]

You saved the query as an Access object? Then you built another query referencing the saved object? That's how I build nested queries. Build them in sequence and make sure they work then I copy/paste the first query into the second.

[sshr]

how do I save it as an Access Object??

[June7]

Use the Access query designer or wizard. Save the query. That is an Access object. Other Access objects are tables, forms, reports.

[sshr]

Thanks June7 for your help!!