Good morning,
I need some help with a SQL select command, not specifically for R:BASE. See my
little table sample below. What I’d like to end up with after the SQL select is
the following rows:
Results of SQL Select/Query
ROWID PART_ID ID1
ID2
1 PV216365006R -00105
-00106
3 PV216365006R -00107
-00108
5 PV216365006R -00109
-00110
7 PV216365006R -00111
-00112
Sample Table to Query
ROWID PART_ID ID1
ID2
1 PV216365006R -00105
-00106
2 PV216365006R -00106
-00105
3 PV216365006R -00107
-00108
4 PV216365006R -00108
-00107
5 PV216365006R -00109
-00110
6 PV216365006R -00110
-00109
7 PV216365006R -00111
-00112
8 PV216365006R -00112
-00111
I know how I’d do this in a Declare statement in R:BASE but as I said, it has
to be done with a SQL select command.
Any blues clues would be greatly appreciated.
TIA,
Paul Buckley
--
For group guidelines, visit
http://www.rbase.com/support/usersgroup_guidelines.php
---
You received this message because you are subscribed to the Google Groups
"RBASE-L" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to rbase-l+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
