|
|
Posted by @sh on 07/07/06 09:38
Thanks for your reply, I see what you're suggesting but its too late to
change the overall structure of the table now ;o(
"MGFoster" <me@privacy.com> wrote in message
news:tOerg.596$vO.300@newsread4.news.pas.earthlink.net...
>
> Your columns "UserHotelIDAccess" and "CampaignHotelIDs" are in violation
> of 1NF (First Normal Form) "A cell must be atomic." I.e., there must
> only be one item per column. If your data was like this:
>
> CampaignID, CampaignName, CampaignHotelIDs
> 1 Test Campaign 1
> 1 Test Campaign 4
> 1 Test Campaign 5
> 1 Test Campaign 7
> 1 Test Campaign 9
> 2 Test Campaign2 1
> 2 Test Campaign2 2
>
> UserID, UserName, UserHotelIDAccess
> 1 Test User 1
> 1 Test User 6
> 1 Test User 7
> 2 Test User 2
> 2 Test User 7
>
> Your WHERE clause would work like this:
>
> WHERE CampaignHotelIDs = UserHotelIDAccess
> --
> MGFoster:::mgf00 <at> earthlink <decimal-point> net
> Oakland, CA (USA)
>
> -----BEGIN PGP SIGNATURE-----
> Version: PGP for Personal Privacy 5.0
> Charset: noconv
>
> iQA/AwUBRK15H4echKqOuFEgEQJqNgCePdnBVao0mJq2YSFXG/GubalXfhMAoNRY
> UlESaxNSeKctgZhjJ5pZ1UFV
> =kzX+
> -----END PGP SIGNATURE-----
Navigation:
[Reply to this message]
|