This is a multi-part message in MIME format.
------=_NextPart_000_0000_01C1297B.F636FE80
Content-Type: text/plain;
charset="Windows-1252"
Content-Transfer-Encoding: 8bit
Alle,
I�m having problems figuring how I should write the query(ies), or the CF
code to accomplish a >= count list. For example:
Table1:
T1-ID
T1-Data
Table2:
T2-ID
T1-ID
T2-Data
For each Table1 entry, I can have one or more Table2 entries.
What I need to do is create a list of those Table1 entries that have a >= X
number of Table2 entries (where X is variable). I don�t need Table2�s data,
just Table1�s.
This one has me a little stumped�
Troy
------=_NextPart_000_0000_01C1297B.F636FE80
Content-Type: application/ms-tnef;
name="winmail.dat"
Content-Transfer-Encoding: base64
Content-Disposition: attachment;
filename="winmail.dat"
eJ8+IgwLAQaQCAAEAAAAAAABAAEAAQeQBgAIAAAA5AQAAAAAAADoAAEIgAcAGAAAAElQTS5NaWNy
b3NvZnQgTWFpbC5Ob3RlADEIAQ2ABAACAAAAAgACAAEGgAMADgAAANEHCAAUAA0AFwAAAAEAGQEB
A5AGAGQMAAAlAAAACwACAAEAAAALACMAAAAAAAMAJgAAAAAACwApAAAAAAADADYAAAAAAB4AcAAB
AAAACgAAAFNRTCBPUiBDRgAAAAIBcQABAAAAFgAAAAHBKWqathva5WuVahHVueYAEGBYPrgAAAIB
HQwBAAAAIwAAAFNNVFA6VFJPWS5LQVJKQUxBLU1BVVpAVC1PTkxJTkUuREUAAAsAAQ4AAAAAQAAG
DgDCBXhqKcEBAgEKDgEAAAAYAAAAAAAAAIN9/vUMrr8Riika2xAlV5HCgAAACwAfDgEAAAACAQkQ
AQAAADEIAAAtCAAA5BQAAExaRnU0gm1DAwAKAHJjcGcxMjVyMgxgYzEDMAEHC2BukQ4QMDMzDxZm
ZQ+STwH3AqQDYwIAY2gKwHOEZXQC0XBycTIAAJIqCqFubxJQIDAB0IUB0DYPoDA1MDQUIfMB0BQQ
NH0HbQKDAFAD1PsR/xMLYhPhFFATshj0FNCTBxMCgzI4EY4yMxphRRdyIAdtIENFGgQ5Txp/FEAb
rxy1eXICgzNzFjERrDE2FjEe/wOCR/0J0WsgdA5QIP8kMSI/A4KeVAhwIHQPwCReNzclfyEctChI
ZWIJcHcp/yB0HsEnrhufKbYHEAGgDeBlKpU1Kx84NixPHLRC/QdAdA3gIHQvwRZsG3gHE/0dBjMo
oTI9HrcztSBWHZH/Fmwh6DO0I4gUUDdPJVcztL0m5jQWPyiIM7QqKzQkMfc8zjM8Lbs0J3E3bS+3
M7RXMUYCkQjmOwlvMEW/Zf0OMDVG6kgBR79IyUbUSPL/R19LL0rtSm9In0bvEGAaUP9QulHRUY9S
mUbUUsJRL1T/71S9VD9Sb1Y0OQ5QWYRa4YdTA1rgAoJzdHlsB5AqaAngdAAAcQMhbGkPAUAFEAFA
A/BkY3RsewqxAGBzCrBeIBbgXmJuBHVtAgBhYXV0bzEAYGRqdVxQBRBnaF50XYEKAV1QCgFpAZBw
/jADMTySDAEPVxAYCNAJwHNd4GIjbnBieWQUAzBz+G5leBcwB7AFsADAAnO5ExBjcw+QAzBf4GRh
QHRpdhOARAEQX5AxYCAaUArAYQnAYWBoIEYbAiFcEzEukF0SZmktPQ+QOGDSadNdnCpQZHLPCVBr
chaga3J3NFAhFwD+cAHQZtFej1+fYKZp02FP92JfY29kfmJtMAmAAiBwcc9lY2kwZ/BgoXQtaJAD
YQo6MDBvdjBTdWJqBQWQdHYwRGF0ZTr/aOQvwGlvan9rj2yfba9uv/9vzFygfTALgA4ScHEMMHCk
Pw5QcS9yP3NPdF91Z1Jl+2dQFwEgKjB9MASQaOQooP93/3kPeh97L3w+CGBeEAuA9mVcgGdQbAFA
fT9+T39UljCPcAjQYgqwdDh/6P1xBjIewBAWkTGB5BNQF3D4b29mgj+DT4RXkACFcHkLUHkvaKCJ
0AsRheVz/2jkGmCG34fviP+KD3w/jQ//b89w34Fvky+UP5VPllJ2Uv919HcpHZBdH14vnB9gT55k
/Y+zOZ6vn7+gz6HfhEiq4LhEb2OoIAnwBUBNnnDvZjabE2cGqwdjAECuqGayP6dghaECIDPhXEAF
oG1w7RNiRQDAAxBTXGIB0FwT/jIAUKX/pw+oH6kvnm+rz9+s363vhAu18LTQLbTyBgDruWC0AHQI
cGVE4xMQRdCCdgJRIHtVbmsTUPp3FdF9ttLB0LcQmcEBgH5udrAAYAnwZwCwAJJheFMLYAJAb3kJ
8FxlgHD/XKAAIAuQE1BnwZnAt5AA4ecCMAJgAIBiZAwwE1EKsH5jARAFsGfAAgFl8H8yZZRcaAWw
esOCZGcAwOxyZwuByGBoxpMvoAFBPGd2ySnH4blgneE3MOcAUMmxyqU5OB7AyPLH4P53yzPMZHbA
xJAAcAsww4GXXGCzsA5QdgiQd2sLgP5kHsDOYgTwB0AQYQFADgDfmZJcsLjwz8UCEG+5kLeQ/ZXg
dMHgjFHC0tFXuYAAwP+4sLeQkmHGALmAuPEJMrkg/4xwAlAHQAuQ1GECUc6xtlDv0WDPUbcQAmB3
1SMCUQAg5wnAtlDDAHJrxwGx4hchHxLyd0C0gMPxE4BDOlzqXHWAb2hBbWiQAxAHkD3YoE0N4ANg
s+ABgCBP9wEgDeDHwFzaVg+TxHC08vouhCB0wiAXELcQlnC58v9lgAFAw1HTYASQx8DcYoxC37yS
MfABQNxjZ5RjwWETAuMAgAWQbHZsAFC4MQUA/7hg3/EBkAAg4HLOsbBBAcF/3+EW4A9wAAC4MAzQ
AZAg/i7AtN/2DlDgksVB4P/iD/3jH2wPwLgwBYHkz+Xf5u9+bB7AuDDVkOSf6V/qZCnf41wukOgv
7Q/qRGIqEAKR/+4v4CMvwOvf8J/xr/K/4FD/KKD0AuDf9W/2f+NcGmD0D//5j/qf+6/gUB2Q+I/+
H/8v/wA0Cvm2QLYvtz+4T7lfum+fu3+8j2SLRRGyVkFsXICoLA0KBQIgDxVJUMD8cXXRABOA2SAW
4M5gCxC+IJKR09DYACzwl8BnJvB3ENLMcQ/gIMxhZ8CWcHdrCQDYUXRcsCAQIJbQeWtFArJWKM5w
c+6QDhksxiDKoBNTQ0YgtGACsPkTUG8gygC0YgYQXKAT+mcW8BerE/o+PRertGB1e7BRF2F040AX
uhlLlhEg12WA2RDYIGUT+joT+g8V+x7fH+xULeDPcXYwE/rX4Bct4A92GTxUE/oxLUl+RCAPI98l
oBP6Jdt3MGEzDxwh8zI6IM8cXlQy/yW/Js8n0y1/Lo8tMnchGHv/Kz8zFx1TygBogCH0HYAEcP8T
0BXAEnDPUAWgEKHYYBP692iw2GAV4W3KoB37JA8pKO8q4herNdIUwS4zPzMfspL+V0AwsGA2QGVw
ReAWwhP6/YQgIELAGUsBoIYA2FHqoPsbYhXQZhNRtKIh9DsfFMHfE1E+4TajGHwaHVg/IAgAPmKW
0EJiKsQ71herKHfX3YJHEUChdgcAaTVyFPv/G68OKDZAhCEQBj7wPzMqxPciexAVSLxkKbEVwAjC
Qv/fT59LTz13PZ8h0WhAoTey/z7QEYCwMEHz1jDXMRuACAB5s7BkhSntkqAT61V2fQIAWzAAAAAL
AAGACCAGAAAAAADAAAAAAAAARgAAAAADhQAAAAAAAAMAE4AIIAYAAAAAAMAAAAAAAABGAAAAAAGF
AAAAAAAAAwAggAggBgAAAAAAwAAAAAAAAEYAAAAAEIUAAAAAAAADAEOACCAGAAAAAADAAAAAAAAA
RgAAAABShQAAJ2oBAAsAUIAIIAYAAAAAAMAAAAAAAABGAAAAAA6FAAAAAAAAAwBSgAggBgAAAAAA
wAAAAAAAAEYAAAAAEYUAAAAAAAADAFOACCAGAAAAAADAAAAAAAAARgAAAAAYhQAAAAAAAB4AfIAI
IAYAAAAAAMAAAAAAAABGAAAAAFSFAAABAAAABAAAADkuMAALAH2ACCAGAAAAAADAAAAAAAAARgAA
AAAGhQAAAAAAAB4AjYAIIAYAAAAAAMAAAAAAAABGAAAAADaFAAABAAAAAQAAAAAAAAAeAI6ACCAG
AAAAAADAAAAAAAAARgAAAAA3hQAAAQAAAAEAAAAAAAAAHgCPgAggBgAAAAAAwAAAAAAAAEYAAAAA
OIUAAAEAAAABAAAAAAAAAAsAlYAIIAYAAAAAAMAAAAAAAABGAAAAAIKFAAABAAAAAgH4DwEAAAAQ
AAAAg33+9QyuvxGKKRrbECVXkQIB+g8BAAAAEAAAAIN9/vUMrr8Riika2xAlV5ECAfsPAQAAAFUA
AAAAAAAAOKG7EAXlEBqhuwgAKypWwgAAUFNUUFJYLkRMTAAAAAAAAAAATklUQfm/uAEAqgA32W4A
AABDOlxNeSBEb2N1bWVudHNcb3V0bG9vay5wc3QAAAAAAwD+DwUAAAADAA00/TcAAAIBfwABAAAA
PQAAADxMUEJCSUtDSkpKS0dPT05BRkxEUEFFQU9DQ0FBLlRyb3kuS2FyamFsYS1NYXV6QHQtb25s
aW5lLmRlPgAAAAADAAYQGzuc6QMABxBmAQAAAwAQEAAAAAADABEQAAAAAB4ACBABAAAAZQAAAEFM
TEUsSZJNSEFWSU5HUFJPQkxFTVNGSUdVUklOR0hPV0lTSE9VTERXUklURVRIRVFVRVJZKElFUyks
T1JUSEVDRkNPREVUT0FDQ09NUExJU0hBPUNPVU5UTElTVEZPUkVYQU0AAAAA2Ak=
------=_NextPart_000_0000_01C1297B.F636FE80--
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
