INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS
Come Join Us!
- Talk With Other Members
- Be Notified Of Responses
To Your Posts
- Keyword Search
- One-Click Access To Your
Favorite Forums
- Automated Signatures
On Your Posts
- Best Of All, It's Free!
*Tek-Tips's functionality depends on members receiving e-mail. By joining you are opting in to receive e-mail.
Partner With Us!
"Best Of Breed" Forums Add Stickiness To Your Site
(Download This Button Today!)
Member Feedback
"...This was the ONLY place that I could find information that I could use to resolve the problem. So thanks once again to member TomSark and the SQL forum!..."
Geography
Where in the world do Tek-Tips members come from?
|
 Cannot copy entire SQL query
|
|
|
Joe1010 (Programmer) |
20 Dec 06 9:59 |
Currently I do not have access to create views. I can only create reports.
My first table has a status field for discontinued items. (It is a text field)
My second table also has all items with more details, but it does not have the status field. I would like to display the information from the second table only for items with status in the first table is <> Y
My problem is that for this report, I must use a combination of 2 fields as the primary key in both tables in order to link it.
I created a report for table one and added a formula field where it combines the 2 fields into one.
When I go to “Show SQL query” it does not include the formula field, so I can not paste it into the Add Command on the second report.
Any idea?
I hope I have explained my situation clear enough. If not please let me know.
Thank you
Joe
|
|
You should create the entire SQL as an Add Command, you don't need a second report.
It also doesn't make sense that you need to concatenate 2 fields to create one for both tables, just join by both fields and it's the same, so you're probably not explaining this fully.
At any rate, use SQL to create the join fields and do everything in the Add Command.
-k |
|
|
 |
|
