joining tables 2 SQL 1 excel

[#1]

I need help in joining tables 2 SQL and 1 Excel file

Three tables with PhrNPI and DateRange   combined hrxs and orderentry

Two tables with RxNo   hrsx and orderentry

is this possible?

[#2]

This is what I have now

[phaneendra_kunc]

You have to drop the PhrNPI too.. add this along with RxNo drop statement.

Drop  Field PhrNPI from  OrderEntry;

[#4]

No Errors YES

but now the sheet does not work

[phaneendra_kunc]

Do me a favor. Can you send me your QVF file to me. I will see what else is missing,

[#6]

How do I attach it

[#7]

The file is 57344KB

[phaneendra_kunc]

try using Free File Hosting - Online Storage; Upload Mp3, Videos, Music. Backup Files

[#9]

ok I changed the date span to include less data

But don't see were to attach it at? !

[phaneendra_kunc]

On reply screen you will see "Advanced Editor" on top right corner. click on that and you will attach option at bottom.

[#11]

Don't see it