Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

query result

Status
Not open for further replies.
keizersoz

keizersoz

Programmer
Apr 22, 2004
67
0
0
BE
Hello I'm designing a universe with BO version 6.5.1. I have some troubles with testing queries.

[to get query Panel:
->double click an object
->object properties
->properties
->edit]

When I drag to objects from different tables (namely table1.PrimaryKey and table2.ForeignKey) on the Query Results Box of the Query Panel. Attempt to generate SQL results in error: QP0004 =incompatible combination of objects.

Why is this happening? What am I doing wrong, and how should I ask a proper query combining more than one table, linked with a key?

thanks a lot,
 
Status
Not open for further replies.

Similar threads

DavianQ
  • Locked
  • Question
Printing Query
Replies
2
Views
43
hilfy
hilfy
TariqMehmod
  • Locked
  • Question
Query from Sqlserver to Crystal Report
Replies
1
Views
59
kray4660
kray4660
dellguy
  • Locked
  • Question
Dynamic parameter populated from command file query issue
Replies
2
Views
74
kray4660
kray4660
jwaldner
  • Locked
  • Question
editing command query removes parameter descriptions 1
Replies
1
Views
18
kenhamady
kenhamady
tlbrown88
  • Locked
  • Question
Exception Report based off of results from Subreports
Replies
5
Views
63
tlbrown88
tlbrown88

Part and Inventory Search

Sponsor

Back
Top