| TIP: Click on subject to list as thread! | ANSI |
| echo: | |
|---|---|
| to: | |
| from: | |
| date: | |
| subject: | SQL related... |
Carol,
>> I think what I'm using can use the first syntax but I'm not for sure.
>>
>> I need to set up some test databases again... ....
> Yeah, the logic is the same but the usage differs a bit. What I see from
> reading about, is we can generally figure out one another and ajust although
> nested selects can get a little hairy.
Besides any separate test databases I might create (and I'm sure I've seen
reference to scripts for creating such things...), I'm thinking of adding
another table to the nodelist database I'm already working with.
Specifically one for DNS related info. Have the zone/net/node/point fields
in that table as well, and can then do joins on that. One thing I would
take into account is that there could be multiple entries for a particular
node in the DNS related table... (A & AAAA, for instance, not that
IPv6 is being used much yet...)
Jame
--- BBBS/LiI v4.01 Flag
* Origin: Rocasa BBS (1:120/546)SEEN-BY: 3/0 633/267 640/954 712/0 313 550 620 848 @PATH: 120/546 544 140/1 261/38 712/848 633/267 |
|
| SOURCE: echomail via fidonet.ozzmosis.com | |
Email questions or comments to sysop@ipingthereforeiam.com
All parts of this website painstakingly hand-crafted in the U.S.A.!
IPTIA BBS/MUD/Terminal/Game Server List, © 2025 IPTIA Consulting™.