New query based on SOME fields returned in another query

I need to have two queries, the second query uses some information from the first query but the second query's results is not a subset of the first query.

this is my first query

select name, date, company, valid
from tbl1, tbl2, tbl3
where valid=0

Then I need to take the person's name to do another query, but I don't need to look in the first set of results to get what I need. It is a brand new query just with the name as the parameter.

select name
from tbl4
where name = @.name

Right now I have the second query getting it's parameter from the first query in RS. The two queries are two different data sets BUT my second query is limited by the results from the first query. How do I get the second query to be it's own query not based on the first but get a parameter from the first query.

I know this is all very confusing. I apologize. I am trying to explain fully.

Please help, I am new to RS and quite new in SQL

Well, I think I solved my problem. I needed to create a sub report.

New Instance Install

I installed another instance of SQL Server onto my
machine. I currently have a personal edition and decided
to install a second instance. It failed at MDAC
installation. When I look at the setup log, it says the
installation failed.
My dilema is that I cannot start the previous installation
I had before. When I activate Enterprise Manager, I get a
Snap-in failed to initialize : Microsoft Enterprise
Manager. I tried everything I know to start SQL - but
cannot. Can someone help please?
Mary.Mary,
Try re-installing MDAC 2.7 SP1 and try it again. Let me know if it still
doesn't work
HTH
Thank you,
Saleem@.sqlnt.com
"Mary Lou" wrote:
> I installed another instance of SQL Server onto my
> machine. I currently have a personal edition and decided
> to install a second instance. It failed at MDAC
> installation. When I look at the setup log, it says the
> installation failed.
> My dilema is that I cannot start the previous installation
> I had before. When I activate Enterprise Manager, I get a
> Snap-in failed to initialize : Microsoft Enterprise
> Manager. I tried everything I know to start SQL - but
> cannot. Can someone help please?
> Mary.
>|||Saleem,
I just got back today and tried your suggestion. Saleem,
it worked like a champ. I want to thank you for your
expert advise. Have a good one.
Mary.
>--Original Message--
>Mary,
>Try re-installing MDAC 2.7 SP1 and try it again. Let me
know if it still
>doesn't work
>HTH
>Thank you,
>Saleem@.sqlnt.com
>"Mary Lou" wrote:
>> I installed another instance of SQL Server onto my
>> machine. I currently have a personal edition and
decided
>> to install a second instance. It failed at MDAC
>> installation. When I look at the setup log, it says
the
>> installation failed.
>> My dilema is that I cannot start the previous
installation
>> I had before. When I activate Enterprise Manager, I
get a
>> Snap-in failed to initialize : Microsoft Enterprise
>> Manager. I tried everything I know to start SQL - but
>> cannot. Can someone help please?
>> Mary.
>.
>

New Instance Install

I installed another instance of SQL Server onto my
machine. I currently have a personal edition and decided
to install a second instance. It failed at MDAC
installation. When I look at the setup log, it says the
installation failed.
My dilema is that I cannot start the previous installation
I had before. When I activate Enterprise Manager, I get a
Snap-in failed to initialize : Microsoft Enterprise
Manager. I tried everything I know to start SQL - but
cannot. Can someone help please?
Mary.
Mary,
Try re-installing MDAC 2.7 SP1 and try it again. Let me know if it still
doesn't work
HTH
Thank you,
Saleem@.sqlnt.com
"Mary Lou" wrote:

> I installed another instance of SQL Server onto my
> machine. I currently have a personal edition and decided
> to install a second instance. It failed at MDAC
> installation. When I look at the setup log, it says the
> installation failed.
> My dilema is that I cannot start the previous installation
> I had before. When I activate Enterprise Manager, I get a
> Snap-in failed to initialize : Microsoft Enterprise
> Manager. I tried everything I know to start SQL - but
> cannot. Can someone help please?
> Mary.
>
|||Saleem,
I just got back today and tried your suggestion. Saleem,
it worked like a champ. I want to thank you for your
expert advise. Have a good one.
Mary.

>--Original Message--
>Mary,
>Try re-installing MDAC 2.7 SP1 and try it again. Let me
know if it still[vbcol=seagreen]
>doesn't work
>HTH
>Thank you,
>Saleem@.sqlnt.com
>"Mary Lou" wrote:
decided[vbcol=seagreen]
the[vbcol=seagreen]
installation[vbcol=seagreen]
get a
>.
>

New Crystal Report Question

Hi guyz! i have a problem with my crystal report 9. im using vb6 in win xp. my prob is when i print my report in second attempt it will just eject the paper without print. but in first, its fine..

here's my code:

MyReportPrintCheck.DiscardSavedData
Set printer = Printers(cmbprinter.ListIndex)
MyReportPrintCheck.SelectPrinter printer.DriverName, printer.DeviceName, printer.Port
MyReportPrintCheck.PaperOrientation = crDefaultPaperOrientation
MyReportPrintCheck.PaperSize = crPaperLetter
MyReportPrintCheck.PrintOut False <-- i think the "False" here is the problem because when i remove the false it will print though it will take time coz it will prompt me a message if i will print all or selection..thats why i put "False" here so that when i click the Print button.. it will automatically print. can anyone help me?

Set MyReportPrintCheck = Nothing

i really appreciate ur reply...

atzMake sure the second page is not empty|||yes, my second report is already empty... but still it will never print... it still eject the paper... when i install my vb6 and cr9 in win 98 and try, it works fine! but when i transfer, i mean install it in win xp. there goes the problem... i think mybe there something with my code... can you give me an example? thanks for your reply... :)