Query Question

[paul41598]

Im trying to run this query, but its not working the way I want to

SELECT `uttstore_history`,`userid` FROM `user` WHERE `uttstore_history` IS NOT NULL

Im basically trying to bring up only the userid's with store purchase history. But its showing all userid's even if they dont have any history

My ultimate goal though is to delete all data from uttstore_history, and I dont know how....?

[Andreas]

[sql]truncate uttstore_history[/sql]

This will clear the table.

[paul41598]

Originally Posted by KirbyDE

[sql]truncate uttstore_history[/sql]

This will clear the table.

k thankyou