Re: [GENERAL] simple linking question

2001-07-19 Thread Justin Clift
Hi Jeremy, It sounds like what you're saying is that you have data in Table A, and you also have data in Table B, but you want one of the fields in Table B to really be from a field in Table A at all times (transparently). Is that right? You could create a VIEW using the CREATE VIEW command

[GENERAL] simple linking question

2001-07-18 Thread Jeremy Hansen
I'm trying to do some more advanced things in sql to make my tables more efficient. I'd like to do a link, or perhaps it's a join, although everything I've looked at relating to a join makes me think that it's not what I'm looking for. What I would like to do is have a field in a table