Thanks Scott, that worked but I do see duplicates. I tried to add distinct in the query and still see duplicates, any idea how to remove duplicates?

Select females_only.*

From dbo.vw_csys_NurserySchool

Cross...

Thank you guys, I really appreciate the efforts.

I think, I probably write it wrong.....basically both of these columns 'Parent1_Gender' and 'Parent2_Gender' has both 'M' and 'F' values.

I want only to...

***Correction...all the parent with 'F' value from both tables.

I meant to say parent with 'F' value from both columns.

no, that will only give me the values both columns have Females.

but my requirement is to list all the parent with 'F' value from both tables.

not sure if I am...

Thanks again Scott for explaining.

Ok, thanks for explaining.

I'm more of a infrastructure DBA, so getting into more development now.

Anyway, I really appreciate the feedbacks.

Yes, it's giving me all activities between 11/30 to 12/1.

Correct?

Thanks Scott, it worked.

Appreciate it.

Thanks Scott, it worked.

Appreciate it.

Thanks Scott.

Sorry, I am really bad at writing queries, trying to learn.

Can you look at the below query and help me.

I need to be able join two tables(Name & Activity)...

Thank you guys, appreciate it.

I just want to confirm one more thing, if I need to avoid duplicates names, select distinct would work right, as shown below?

SELECT distinct "Name"."ID", "Name"."LAST_NAME",...

How do I add this into my query ?

SELECT "Name"."ID", "Name"."LAST_NAME", "Name"."FIRST_NAME", "Name"."EMAIL", "Activity"."ACTIVITY_TYPE", "Activity"."PRODUCT_CODE", "Activity"."TRANSACTION_DATE", "Name"."BIRTH_DATE"

FROM "IMIS"."dbo"."Activity" "Activity" INNER JOIN "IMIS"."dbo"."Name" "Name" ON "Activity"."ID"="Name"."ID"

WHERE ("Activity"."ACTIVITY_TYPE"='MEETING' OR...

Thank you all.

Thank you so much SoHelpmeCodd.

Quick question.

What would be a scenario where you would want to enable auto-close?