View previous topic :: View next topic
|
Author |
Message |
kishpra
New User
Joined: 24 May 2010 Posts: 92 Location: Pune
|
|
|
|
Hi ,
1) How many predicates on join query on 7 tables ?
2) There are two numeric fields one has VALUE as SPACES.If first field is moved to second one what will happen ?
A - It will give compilation error at first field
3) Two files one with 500 records and other with 5000 records which is master file and how to compare them ?
Thanks! |
|
Back to top |
|
|
Escapa
Senior Member
Joined: 16 Feb 2007 Posts: 1399 Location: IL, USA
|
|
|
|
Quote: |
3) Two files one with 500 records and other with 5000 records which is master file and how to compare them ?
|
What question is this?
Answer: Anything...
How to compare? based what level of comparison is to be done. |
|
Back to top |
|
|
Bill Woodger
Moderator Emeritus
Joined: 09 Mar 2011 Posts: 7309 Location: Inside the Matrix
|
|
|
|
Quote: |
2) There are two numeric fields one has VALUE as SPACES.If first field is moved to second one what will happen ? |
What sort of numeric?
If you are saying can any NUMERIC have a VALUE clause when defined that says SPACE, then no, you'd get a compile error. Irrelevant to second numeric field, it definition of field one would give the error.
Dumb question again, insufficient information to provide a reasonable answer inside 20 minutes. |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
A) you can join without any predicate , but then you get cardinal products.
To avoid this you need at least 6 predicates. |
|
Back to top |
|
|
|