[SQL] database design and diagraming book recommendations..

anyone know of a good book or books on database modeling? like for entity relationship diagrams and such.. thanks!

[SQL] Re: car mileage summation / sledgehammer method

great! Thanks for taking the time to demonstrate this! - Original Message - From: "Oliver Seidel" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]>; "Francisco Hernandez" <[EMAIL PROTECTED]>; "Volker Paul" <[EMAIL PROTECTED]> Sent: W

[SQL] variables in SQL??

anyone know if SQL has variables? what im trying to do is have a Sum of a colum.. as it goes forwards with the cursor.. like so: Price|Sum 5|5 4|9 10|19 2|21 7|28 i can do it in the accessing language.. like PHP, Python, Perl etc.. but i wanted to know if the actuall DB could do it? any ideas?

[SQL] eliminating duplicates in results..

hello everyone, i have a query like so: select item.type as ig_id,item.with_design,item_group.type as group_name, 'true' as valid from item,item_group where item.description ~* 'w/out' and item.type = item_group.ig_id; and i get duplicates.. how could i remove all the duplicate entrys using SQL?