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 bkrike 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
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

bbranco
  • Locked
  • Question
Query Help - Group By 2 tables
Replies
0
Views
408
bbranco
bbranco
DavianQ
  • Locked
  • Question
Printing Query
Replies
2
Views
251
hilfy
hilfy
TariqMehmod
  • Locked
  • Question
Query from Sqlserver to Crystal Report
Replies
1
Views
249
kray4660
kray4660
dellguy
  • Locked
  • Question
Dynamic parameter populated from command file query issue
Replies
2
Views
266
kray4660
kray4660
jwaldner
  • Locked
  • Question
editing command query removes parameter descriptions 1
Replies
1
Views
162
kenhamady
kenhamady

Part and Inventory Search

Sponsor

Back
Top