help with query

[liam_dalton]

Hello, I found this on Google: http://www.codingforums.com/archive/index.php/t-96084.html

and was wondering, what are those c. , p. things? Are they shorthand for something?

[oesxyl]

Hello, I found this on Google: http://www.codingforums.com/archive/index.php/t-96084.html

and was wondering, what are those c. , p. things? Are they shorthand for something?
alias. You can give a name to a table for example:

select * from mytable as myt

you can use myt instead of mytable and when you adress a field you can use myt.myfield instead of mytable.myfield.

http://dev.mysql.com/doc/refman/4.1/en/identifiers.html

best regards

[liam_dalton]

Thanks very much for your help!

[oesxyl]

Thanks very much for your help!
you are welcome, :), and also welcome to the forum, :)

best regards

[liam_dalton]

Hello, thanks for the warm welcome. I hope to learn lots here! :thumbsup: