|
Posted by Frankly on 07/18/06 18:56
"J.O. Aho" <user@example.net> wrote in message
news:4i4bauF22d6jU1@individual.net...
>Of course as testing and learning to understand how things works it's okey
>to get both ApartmentID's.
i guess this is what I will do. I will do some finall touch ups and FINALLY
put some data in.
there is so much more I could comment on about your post. at this point i
think you are right.
I should test to understand how things work.
there are still more joins i will need to make.
as time went by we changed tables around a bit.
i will give a some detail about the tables I have.
each table contains more fields, i only listed those that will be needed for
joins.
Managements Table
State
ZipCode
WebSite
Buildings Table
Area
ZipCode
RelationBuildingsManagements Table
<ManagementID
<BuildingID
Apartments Table
<BuildingID
ImageTable
<ImageID
<ApartmentID
<BuildingID
<Notes
AddsPosted Table
<Name of location posted at.
<ApartmentID
AreaZipCode table
<ZipCode
<Area
drum roll press send
Frank
Navigation:
[Reply to this message]
|